{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}/Users/sebastiantonke/Desktop/Replication Package/Replication files experiment/output_logs/table 2.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}11 Jul 2023, 14:17:26
{txt}
{com}. 
. tab completed itt if t==12 & itt!=., col // Take-up rates
{txt}
{c TLC}{hline 19}{c TRC}
{c |} Key{col 21}{c |}
{c LT}{hline 19}{c RT}
{c |}{space 5}{it:frequency}{col 21}{c |}
{c |}{space 1}{it:column percentage}{col 21}{c |}
{c BLC}{hline 19}{c BRC}

           {c |}               itt
 completed {c |}         0          1          2 {c |}     Total
{hline 11}{c +}{hline 33}{c +}{hline 10}
         0 {c |}{res}        33         93         86 {txt}{c |}{res}       212 
           {txt}{c |}{res}      1.00       2.81       2.63 {txt}{c |}{res}      2.15 
{txt}{hline 11}{c +}{hline 33}{c +}{hline 10}
         1 {c |}{res}     3,267      3,219      3,178 {txt}{c |}{res}     9,664 
           {txt}{c |}{res}     99.00      97.19      97.37 {txt}{c |}{res}     97.85 
{txt}{hline 11}{c +}{hline 33}{c +}{hline 10}
     Total {c |}{res}     3,300      3,312      3,264 {txt}{c |}{res}     9,876 
           {txt}{c |}{res}    100.00     100.00     100.00 {txt}{c |}{res}    100.00 
{txt}
{com}. tab SMS_Statuscoded itt if t>=14 & t<=22 & itt!=., col // Delivery of text messages
{txt}
{c TLC}{hline 19}{c TRC}
{c |} Key{col 21}{c |}
{c LT}{hline 19}{c RT}
{c |}{space 5}{it:frequency}{col 21}{c |}
{c |}{space 1}{it:column percentage}{col 21}{c |}
{c BLC}{hline 19}{c BRC}

SMS_Status {c |}               itt
     coded {c |}         0          1          2 {c |}     Total
{hline 11}{c +}{hline 33}{c +}{hline 10}
         0 {c |}{res}     3,408      3,319      3,294 {txt}{c |}{res}    10,021 
           {txt}{c |}{res}     11.69      11.54      11.62 {txt}{c |}{res}     11.62 
{txt}{hline 11}{c +}{hline 33}{c +}{hline 10}
         1 {c |}{res}    25,739     25,447     25,044 {txt}{c |}{res}    76,230 
           {txt}{c |}{res}     88.31      88.46      88.38 {txt}{c |}{res}     88.38 
{txt}{hline 11}{c +}{hline 33}{c +}{hline 10}
     Total {c |}{res}    29,147     28,766     28,338 {txt}{c |}{res}    86,251 
           {txt}{c |}{res}    100.00     100.00     100.00 {txt}{c |}{res}    100.00 
{txt}
{com}. tab attritionrate itt if t==12 & itt!=., col chi // attrition rates not significantly different
{txt}
{c TLC}{hline 19}{c TRC}
{c |} Key{col 21}{c |}
{c LT}{hline 19}{c RT}
{c |}{space 5}{it:frequency}{col 21}{c |}
{c |}{space 1}{it:column percentage}{col 21}{c |}
{c BLC}{hline 19}{c BRC}

attritionr {c |}               itt
       ate {c |}         0          1          2 {c |}     Total
{hline 11}{c +}{hline 33}{c +}{hline 10}
         0 {c |}{res}     3,253      3,270      3,213 {txt}{c |}{res}     9,736 
           {txt}{c |}{res}     98.58      98.73      98.44 {txt}{c |}{res}     98.58 
{txt}{hline 11}{c +}{hline 33}{c +}{hline 10}
         1 {c |}{res}        47         42         51 {txt}{c |}{res}       140 
           {txt}{c |}{res}      1.42       1.27       1.56 {txt}{c |}{res}      1.42 
{txt}{hline 11}{c +}{hline 33}{c +}{hline 10}
     Total {c |}{res}     3,300      3,312      3,264 {txt}{c |}{res}     9,876 
           {txt}{c |}{res}    100.00     100.00     100.00 {txt}{c |}{res}    100.00 

{txt}          Pearson chi2({res}2{txt}) = {res}  1.0210  {txt} Pr = {res}0.600
{txt}
{com}. 
. 
. ** Checking for differential attrition
. foreach var in paymentw paymentcondw invoicesw prepaidcounttotal preclosingbalancew preage_of_account {c -(}
{txt}  2{com}. reg `var' i.itt if everattrited==1 & t<=12, vce(cluster customer)
{txt}  3{com}. {c )-}

{txt}Linear regression                               Number of obs     = {res}     1,552
                                                {txt}F(2, 185)         =  {res}     0.91
                                                {txt}Prob > F          = {res}    0.4033
                                                {txt}R-squared         = {res}    0.0018
                                                {txt}Root MSE          =    {res} 320.18

{txt}{ralign 78:(Std. Err. adjusted for {res:186} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}    paymentw{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} .5881889{col 26}{space 2} 32.41669{col 37}{space 1}    0.02{col 46}{space 3}0.986{col 54}{space 4}-63.36573{col 67}{space 3} 64.54211
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-28.14124{col 26}{space 2} 24.64942{col 37}{space 1}   -1.14{col 46}{space 3}0.255{col 54}{space 4}-76.77135{col 67}{space 3} 20.48887
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2}  134.127{col 26}{space 2}  20.4486{col 37}{space 1}    6.56{col 46}{space 3}0.000{col 54}{space 4} 93.78454{col 67}{space 3} 174.4694
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}       450
                                                {txt}F(2, 155)         =  {res}     0.74
                                                {txt}Prob > F          = {res}    0.4785
                                                {txt}R-squared         = {res}    0.0053
                                                {txt}Root MSE          =    {res} 548.56

{txt}{ralign 78:(Std. Err. adjusted for {res:156} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}paymentcondw{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2}-26.18431{col 26}{space 2} 103.9204{col 37}{space 1}   -0.25{col 46}{space 3}0.801{col 54}{space 4}-231.4674{col 67}{space 3} 179.0988
{txt}{space 10}2  {c |}{col 14}{res}{space 2} -97.1866{col 26}{space 2} 88.48118{col 37}{space 1}   -1.10{col 46}{space 3}0.274{col 54}{space 4}-271.9712{col 67}{space 3} 77.59799
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 501.7074{col 26}{space 2} 74.78893{col 37}{space 1}    6.71{col 46}{space 3}0.000{col 54}{space 4} 353.9703{col 67}{space 3} 649.4445
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}     1,552
                                                {txt}F(2, 185)         =  {res}     0.02
                                                {txt}Prob > F          = {res}    0.9762
                                                {txt}R-squared         = {res}    0.0001
                                                {txt}Root MSE          =    {res} 342.31

{txt}{ralign 78:(Std. Err. adjusted for {res:186} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}   invoicesw{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} 6.967882{col 26}{space 2} 37.90098{col 37}{space 1}    0.18{col 46}{space 3}0.854{col 54}{space 4}-67.80582{col 67}{space 3} 81.74159
{txt}{space 10}2  {c |}{col 14}{res}{space 2} 7.088152{col 26}{space 2} 38.70676{col 37}{space 1}    0.18{col 46}{space 3}0.855{col 54}{space 4}-69.27524{col 67}{space 3} 83.45155
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 160.3303{col 26}{space 2} 24.22756{col 37}{space 1}    6.62{col 46}{space 3}0.000{col 54}{space 4} 112.5325{col 67}{space 3} 208.1282
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}     1,552
                                                {txt}F(2, 185)         =  {res}     1.09
                                                {txt}Prob > F          = {res}    0.3376
                                                {txt}R-squared         = {res}    0.0150
                                                {txt}Root MSE          =    {res} 2.5052

{txt}{ralign 78:(Std. Err. adjusted for {res:186} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}prepaidcou~l{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} .4734246{col 26}{space 2} .5766162{col 37}{space 1}    0.82{col 46}{space 3}0.413{col 54}{space 4} -.664164{col 67}{space 3} 1.611013
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-.2441756{col 26}{space 2} .4828672{col 37}{space 1}   -0.51{col 46}{space 3}0.614{col 54}{space 4} -1.19681{col 67}{space 3} .7084585
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 2.866817{col 26}{space 2} .4057371{col 37}{space 1}    7.07{col 46}{space 3}0.000{col 54}{space 4} 2.066351{col 67}{space 3} 3.667284
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}     1,552
                                                {txt}F(2, 185)         =  {res}     0.14
                                                {txt}Prob > F          = {res}    0.8666
                                                {txt}R-squared         = {res}    0.0015
                                                {txt}Root MSE          =    {res}   2145

{txt}{ralign 78:(Std. Err. adjusted for {res:186} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}preclosing~w{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} 200.1212{col 26}{space 2} 408.2252{col 37}{space 1}    0.49{col 46}{space 3}0.625{col 54}{space 4}-605.2539{col 67}{space 3} 1005.496
{txt}{space 10}2  {c |}{col 14}{res}{space 2} 166.9273{col 26}{space 2} 429.4079{col 37}{space 1}    0.39{col 46}{space 3}0.698{col 54}{space 4}-680.2388{col 67}{space 3} 1014.093
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 600.3319{col 26}{space 2} 261.2485{col 37}{space 1}    2.30{col 46}{space 3}0.023{col 54}{space 4}  84.9226{col 67}{space 3} 1115.741
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}     1,552
                                                {txt}F(2, 185)         =  {res}     0.23
                                                {txt}Prob > F          = {res}    0.7965
                                                {txt}R-squared         = {res}    0.0031
                                                {txt}Root MSE          =    {res} 50.537

{txt}{ralign 78:(Std. Err. adjusted for {res:186} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}preage_of_~t{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2}-3.223083{col 26}{space 2} 11.81552{col 37}{space 1}   -0.27{col 46}{space 3}0.785{col 54}{space 4}-26.53356{col 67}{space 3}  20.0874
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-7.080485{col 26}{space 2} 11.02086{col 37}{space 1}   -0.64{col 46}{space 3}0.521{col 54}{space 4} -28.8232{col 67}{space 3} 14.66224
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 46.21445{col 26}{space 2} 9.305451{col 37}{space 1}    4.97{col 46}{space 3}0.000{col 54}{space 4}   27.856{col 67}{space 3} 64.57289
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}
{com}. 
. tab reliable itt if t==12 & itt!=., col // common commitments self-concept treatment
{txt}
{c TLC}{hline 19}{c TRC}
{c |} Key{col 21}{c |}
{c LT}{hline 19}{c RT}
{c |}{space 5}{it:frequency}{col 21}{c |}
{c |}{space 1}{it:column percentage}{col 21}{c |}
{c BLC}{hline 19}{c BRC}

           {c |}    itt
  reliable {c |}         1 {c |}     Total
{hline 11}{c +}{hline 11}{c +}{hline 10}
         + {c |}{res}     1,090 {txt}{c |}{res}     1,090 
           {txt}{c |}{res}     32.91 {txt}{c |}{res}     32.91 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
        ++ {c |}{res}     2,077 {txt}{c |}{res}     2,077 
           {txt}{c |}{res}     62.71 {txt}{c |}{res}     62.71 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
         - {c |}{res}        11 {txt}{c |}{res}        11 
           {txt}{c |}{res}      0.33 {txt}{c |}{res}      0.33 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
         . {c |}{res}        75 {txt}{c |}{res}        75 
           {txt}{c |}{res}      2.26 {txt}{c |}{res}      2.26 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
         / {c |}{res}        36 {txt}{c |}{res}        36 
           {txt}{c |}{res}      1.09 {txt}{c |}{res}      1.09 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
         U {c |}{res}        23 {txt}{c |}{res}        23 
           {txt}{c |}{res}      0.69 {txt}{c |}{res}      0.69 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
     Total {c |}{res}     3,312 {txt}{c |}{res}     3,312 
           {txt}{c |}{res}    100.00 {txt}{c |}{res}    100.00 
{txt}
{com}. tab how itt if t==12 & itt!=., col // common commitments plan treatment
{txt}
{c TLC}{hline 19}{c TRC}
{c |} Key{col 21}{c |}
{c LT}{hline 19}{c RT}
{c |}{space 5}{it:frequency}{col 21}{c |}
{c |}{space 1}{it:column percentage}{col 21}{c |}
{c BLC}{hline 19}{c BRC}

           {c |}    itt
       how {c |}         2 {c |}     Total
{hline 11}{c +}{hline 11}{c +}{hline 10}
         + {c |}{res}     1,440 {txt}{c |}{res}     1,440 
           {txt}{c |}{res}     44.12 {txt}{c |}{res}     44.12 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
        ++ {c |}{res}     1,612 {txt}{c |}{res}     1,612 
           {txt}{c |}{res}     49.39 {txt}{c |}{res}     49.39 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
         . {c |}{res}        83 {txt}{c |}{res}        83 
           {txt}{c |}{res}      2.54 {txt}{c |}{res}      2.54 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
         / {c |}{res}        58 {txt}{c |}{res}        58 
           {txt}{c |}{res}      1.78 {txt}{c |}{res}      1.78 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
         0 {c |}{res}        71 {txt}{c |}{res}        71 
           {txt}{c |}{res}      2.18 {txt}{c |}{res}      2.18 
{txt}{hline 11}{c +}{hline 11}{c +}{hline 10}
     Total {c |}{res}     3,264 {txt}{c |}{res}     3,264 
           {txt}{c |}{res}    100.00 {txt}{c |}{res}    100.00 
{txt}
{com}. tab when itt if t==12 & itt!=., col // plans to pay in october
{txt}
{c TLC}{hline 19}{c TRC}
{c |} Key{col 21}{c |}
{c LT}{hline 19}{c RT}
{c |}{space 5}{it:frequency}{col 21}{c |}
{c |}{space 1}{it:column percentage}{col 21}{c |}
{c BLC}{hline 19}{c BRC}

                 {c |}    itt
            when {c |}         2 {c |}     Total
{hline 17}{c +}{hline 11}{c +}{hline 10}
               . {c |}{res}        92 {txt}{c |}{res}        92 
                 {txt}{c |}{res}      2.82 {txt}{c |}{res}      2.82 
{txt}{hline 17}{c +}{hline 11}{c +}{hline 10}
               / {c |}{res}        79 {txt}{c |}{res}        79 
                 {txt}{c |}{res}      2.42 {txt}{c |}{res}      2.42 
{txt}{hline 17}{c +}{hline 11}{c +}{hline 10}
        DECEMBER {c |}{res}        20 {txt}{c |}{res}        20 
                 {txt}{c |}{res}      0.61 {txt}{c |}{res}      0.61 
{txt}{hline 17}{c +}{hline 11}{c +}{hline 10}
        FEBRUARY {c |}{res}         1 {txt}{c |}{res}         1 
                 {txt}{c |}{res}      0.03 {txt}{c |}{res}      0.03 
{txt}{hline 17}{c +}{hline 11}{c +}{hline 10}
         JANUARY {c |}{res}         7 {txt}{c |}{res}         7 
                 {txt}{c |}{res}      0.21 {txt}{c |}{res}      0.21 
{txt}{hline 17}{c +}{hline 11}{c +}{hline 10}
        NOVEMBER {c |}{res}        85 {txt}{c |}{res}        85 
                 {txt}{c |}{res}      2.60 {txt}{c |}{res}      2.60 
{txt}{hline 17}{c +}{hline 11}{c +}{hline 10}
         OCTOBER {c |}{res}     2,824 {txt}{c |}{res}     2,824 
                 {txt}{c |}{res}     86.52 {txt}{c |}{res}     86.52 
{txt}{hline 17}{c +}{hline 11}{c +}{hline 10}
OCTOBER/NOVEMBER {c |}{res}         3 {txt}{c |}{res}         3 
                 {txt}{c |}{res}      0.09 {txt}{c |}{res}      0.09 
{txt}{hline 17}{c +}{hline 11}{c +}{hline 10}
       SEPTEMBER {c |}{res}       153 {txt}{c |}{res}       153 
                 {txt}{c |}{res}      4.69 {txt}{c |}{res}      4.69 
{txt}{hline 17}{c +}{hline 11}{c +}{hline 10}
           Total {c |}{res}     3,264 {txt}{c |}{res}     3,264 
                 {txt}{c |}{res}    100.00 {txt}{c |}{res}    100.00 
{txt}
{com}. tab lang itt if t==12 & itt!=., col // call in oshiwambo
{txt}
{c TLC}{hline 19}{c TRC}
{c |} Key{col 21}{c |}
{c LT}{hline 19}{c RT}
{c |}{space 5}{it:frequency}{col 21}{c |}
{c |}{space 1}{it:column percentage}{col 21}{c |}
{c BLC}{hline 19}{c BRC}

           {c |}               itt
      lang {c |}         0          1          2 {c |}     Total
{hline 11}{c +}{hline 33}{c +}{hline 10}
         . {c |}{res}        45        145        109 {txt}{c |}{res}       299 
           {txt}{c |}{res}      1.36       4.38       3.34 {txt}{c |}{res}      3.03 
{txt}{hline 11}{c +}{hline 33}{c +}{hline 10}
         E {c |}{res}       934        730        764 {txt}{c |}{res}     2,428 
           {txt}{c |}{res}     28.30      22.04      23.41 {txt}{c |}{res}     24.58 
{txt}{hline 11}{c +}{hline 33}{c +}{hline 10}
         O {c |}{res}     2,321      2,437      2,391 {txt}{c |}{res}     7,149 
           {txt}{c |}{res}     70.33      73.58      73.25 {txt}{c |}{res}     72.39 
{txt}{hline 11}{c +}{hline 33}{c +}{hline 10}
     Total {c |}{res}     3,300      3,312      3,264 {txt}{c |}{res}     9,876 
           {txt}{c |}{res}    100.00     100.00     100.00 {txt}{c |}{res}    100.00 
{txt}
{com}. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}/Users/sebastiantonke/Desktop/Replication Package/Replication files experiment/output_logs/table 2.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}11 Jul 2023, 14:17:27
{txt}{.-}
{smcl}
{txt}{sf}{ul off}